package com.ncp.model.biz.registerlogin;

import java.util.ArrayList;
import java.util.List;

import javax.servlet.jsp.jstl.sql.Result;

import com.ncp.model.dao.DB;
import com.ncp.model.dao.DbConnection;

public class checkEmailBiz {
	private  DB common = new DB();
    public  boolean isRegisteredemail(String Email){
    	boolean b=false;
    	String userEmail = Email;
    	String sql="Select * FROM USERBASIC where EMail='"+userEmail+"'";   
    	common.setSql(sql);
		common.setConn(DbConnection.getConnByDataSource());
		List<Object> list=new ArrayList<Object>();
		common.setList(list);
		Result r=common.executeQuery();
		if(r.getRowCount()>0){
			b = true;
		}
    	return b;	
    }
}

